SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE VIEW dbo.vweReclamos
AS
SELECT        idReclamo AS ID, Agente, Fecha, Tipo, Descripcion, Responsable, Estado, FechaResolucion
FROM            dbo.tb_Reclamos
GO
GRANT SELECT ON  [dbo].[vweReclamos] TO [AdministracionSagenet]
GRANT INSERT ON  [dbo].[vweReclamos] TO [AdministracionSagenet]
GRANT DELETE ON  [dbo].[vweReclamos] TO [AdministracionSagenet]
GRANT UPDATE ON  [dbo].[vweReclamos] TO [AdministracionSagenet]
GRANT SELECT ON  [dbo].[vweReclamos] TO [adm-sage]
GRANT INSERT ON  [dbo].[vweReclamos] TO [adm-sage]
GRANT DELETE ON  [dbo].[vweReclamos] TO [adm-sage]
GRANT UPDATE ON  [dbo].[vweReclamos] TO [adm-sage]
GO
